package com.azure.mapper.report;

import com.azure.entity.ATurnoverMonthlyReport;
import com.azure.entity.ATurnoverMonthlyReportExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface ATurnoverMonthlyReportMapper {
    int countByExample(ATurnoverMonthlyReportExample example);

    int deleteByExample(ATurnoverMonthlyReportExample example);

    int deleteByPrimaryKey(Long id);

    int insert(ATurnoverMonthlyReport record);

    int insertSelective(ATurnoverMonthlyReport record);

    List<ATurnoverMonthlyReport> selectByExample(ATurnoverMonthlyReportExample example);

    ATurnoverMonthlyReport selectByPrimaryKey(Long id);

    int updateByExampleSelective(@Param("record") ATurnoverMonthlyReport record, @Param("example") ATurnoverMonthlyReportExample example);

    int updateByExample(@Param("record") ATurnoverMonthlyReport record, @Param("example") ATurnoverMonthlyReportExample example);

    int updateByPrimaryKeySelective(ATurnoverMonthlyReport record);

    int updateByPrimaryKey(ATurnoverMonthlyReport record);

    @Select("select * from a_turnover_monthly_report where date = #{date} order by turnover desc")
    List<ATurnoverMonthlyReport> getMonthlyTurnoverData(String date);
}